Example: Find current registrants
This query joins two business objects to extract the registrants for a specified event. At runtime the user can supply the event code.
- Browse to IQA.
- Select Query from the drop-down list and select New.
- Select the sources and define the relation:
- Browse to the Common folder containing business objects.
- Select Contact and CsEventHistory.
- In the Relations area of the Sources tab, make sure the default relation is Contact.Id Equals CsEventHistory.Id.
- Define the filtering rules:
- Select the Filters tab.
- Mode: Advanced
- Filter on CsEventHistory.Event.
- Property: CsEventHistory.Event
- Comparison: Equal
- Select Yes from the Prompt drop-down list and enter a prompt in the field located next to the field. For example, Event Code.
- Add the filter.
- Save your settings.
- Define the columns to display in the output:
- Select the Display tab.
- Select the following columns: CsContact.Id, and CsEventHistory.Event.
Note: A default list of columns displays when you select the Display tab. Deselect the columns you do not need. If a column you need is not in the default list, select All from the View drop-down list and scroll down the page to select the desired column.
- Using the Order drop-down list, assign:
- CsContact.Id Order 1
- CsEvent.Event Order 2.
- Specify the sorting priority:
- Select the Sorting tab.
- Sort the results by CsEventHistory.Event.
- Add the selection.
- Save your settings.
- Run the query.